package com.luchao.ptz.repository;

import com.luchao.ptz.pojo.PwThreads;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

public interface PwThreadsRepository extends JpaRepository<PwThreads, Long> {

    @Query(value = "SELECT * FROM pw_threads WHERE fid != 0 ORDER BY tid DESC", nativeQuery = true)
    List<PwThreads> getAll();
}
